Skip Headers

Oracle Procedural Gateway® Visual Workbench for WebSphere MQ Installation and User's Guide 10g Release 2 (10.2) for Microsoft Windows (32-Bit) Part Number B19082-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A C D E F G H I J K M N O P Q R S T U V W

## A

  Acknowledgment parameter
    for message queue profile, 6.5
    with Response Queue, 6.5
  administrative user, creating, 5.4.2.5

## C

  character sets
    in data profiles, 6.3
  choosing a repository server, 5.4.1.1
  CLOSE_CACHED_OPEN_CURSOR initialization parameter, 2.4.1
  COBOL
    copybook, 6.1
    copybook file parameter, 6.3
    data definition, 6.3
    data profile, 6.4, 6.4.1
    data profile (example), 6.3
    data type conversion, 7.12
    FILLER data type conversion, 7.12.4
    format conversion, 7.13
    JUSTIFIED, 7.13.1
    JUSTIFIED LEFT, 7.13.2
    JUSTIFIED RIGHT, 7.13.1
    messages, 6.1
    OCCURS clause, 7.13.3, 7.13.4
    PIC 9 data type conversion, 7.12.3
    PIC G data type conversion, 7.12.2
    PIC X data type conversion, 7.12.1
    RENAMES clause, 7.13.5, 7.13.6
    supported version, 1.3.1.1
    SYNCHRONIZED, 7.13.7
    SYNCHRONIZED LEFT, 7.13.8
    SYNCHRONIZED RIGHT, 7.13.7
    version, parameter for data profile, 6.3
  code
    data mapping, 6.8.2
    template, 6.8.2
    viewing the generated code, 6.8.2
  compatibility
    MIP and beta version MIP, 2.2, 6.8.1
  compilation errors, 6.11
  compiling the MIP, 6.11
  Connect dialog box, 6.2
  connecting to a repository, 6.2
  copybook
    and data mapping information, 6.3
    COBOL, 6.1
    sample files, 6.3
  correlation parameter, 7.10.2.1
  creating
    a message queue profile, 6.5
    an interface profile and generating a MIP, 6.8
    data profiles, 6.3
    the administrative user, 5.4.2.5
  cursors, maximum open, 2.4.1

## D

  data conversion
    COBOL, 7.12
    FILLER, 7.12.4
    package
      description, 7.11
      duplicate names of record types, 7.14.4
      EMPLOYEE, 7.11
      gateway test code, 6.10
      in run-time environments, 7.11
      name prefixed as the leftmost qualifier, 7.14.2
      using MIP templates, 6.12
      using PL/SQL RECORDs of TABLEs, 7.13.3
      warnings with JUSTIFIED LEFT, 7.13.2
      with WHEN criterion, 7.13.6
    PIC 9, 7.12.3
    PIC G, 7.12.2
    PIC X, 7.12.1
    PIC X example, 7.12.1
    PL/SQL mapping example, 7.11
    PL/SQL naming algorithm, 7.14.1
    required PL/SQL packages, 7.11
  Data Definition Name
    parameter for data profile, 6.3
  data dictionary
    checked by pgvwbrepos.sql script, 5.4.2.2
  data mapping package, 6.8.2
  data profile
    COBOL, 6.4, 6.4.1
    creating, 6.3, 6.3
    Define COBOL Data Definition dialog box, 6.3
    definition, 6.3, 7.1.1
    EMPLOYEE, 7.1.2
    ENQUEUE and DEQUEUE procedures, 7.1.1.2
    generated data mapping, 6.8.2
    introduction, 1.3.1.1
    message exchange, 6.1
    PL/SQL mapping, 6.3
    removing, 6.4.1
    updating, 6.4
  database link
    connecting MIP to a procedural gateway, 7.1.1
  data-mapping code
    invoked by MIP, 7.1.1
  DBMS_OUTPUT package, 5.4.1.4, 5.4.2.3, 6.13.1, 7.11, A.1, A.2
  DBMS_PIPE package, 5.4.2.3, 6.13.1, A.1, A.2
  default
    character set (NLS), 6.3
    gateway test, 6.10
    port number, 6.2
    SID, 6.2
  Define COBOL Data Definition dialog box, 6.3, 6.4
  delimiters, in data conversion, 7.14.1
  Delivery Mode
    parameter for message queue profile, 6.5
  DEQUEUE
    advanced procedure, 7.6.3
    and "no messages available" exception, 6.12.2.2
    basic procedure, 7.6.2
    data conversion package and, 7.11
    DEQUEUE_OPTIONS_Typ, 7.7.3, 7.7.3
    in the MIP, 7.6
    MESSAGE_PROPERTIES_Typ, 7.8
    mode, 6.5
    naming and name resolution, 7.6.1
    procedure, 6.12, 6.12.1, 7.1.1, 7.1.1.2
    template, 6.12.1
    test, 6.12.2.2
    testing
      the procedure template, 6.12.2.2
      through the gateway, 6.10
    Visibility parameter, 6.5
    Wait Interval parameter, 6.5
  Dequeue Mode
    parameter for message queue profile, 6.5
  dequeue_options parameter, 7.6.3, 7.7.3
  DEQUEUE_OPTIONS_Typ type definition, 7.7.3
  DESCRIBE statement, 5.4.1.3, 5.4.1.4
  development, overview of process, 6.1
  dialog box
    Connect, 6.2
    Define COBOL Data Definition, 6.3, 6.4
    Error Messages, 6.11
    Message Interface Package Compiler, 6.11, 6.13.2
    Message Interface Package Tester, 6.10, 6.12.2.1, 6.12.2.2
    WebSphere MQ Properties, 6.5
  directory, script file, 5.4.1.2
  DO_DEPOSIT
    ENQUEUE DEPOSIT example, 6.12
    MIP example, 6.8.2, 6.8.2
  duplicate names, in data conversion, 7.14.4

## E

  EMPLOYEE data profile, 7.1.2
  ENQUEUE
    advanced procedure, 7.5.3
    basic procedure, 7.5.2
    data conversion package and, 7.11
    DEPOSIT template, 6.12
    ENQUEUE_OPTIONS_Typ, 7.7.2, 7.7.2
    in the MIP, 7.5
    MESSAGE_PROPERTIES_Typ, 7.8
    naming and name resolution, 7.5.1
    on the General panel, 6.10
    procedure, 6.12, 6.12.1, 7.1.1, 7.1.1.2, 7.5.2
    procedure, advanced, 7.5.3
    sample code example, 6.12.1
    sample ENQUEUE DEPOSIT template code, 6.12
    template, 6.12.1
    testing the ENQUEUE procedure template, 6.12.2.1
    testing the procedure template, 6.12.2.1
    testing through the gateway, 6.10
    Visibility parameter, 6.5
  enqueue_operations parameter, 7.5.3
  enqueue_options parameter, 7.7.2
  ENQUEUE_OPTIONS_Typ type definition, 7.7.2
  error
    compilation, 6.11
  error message
    ORA-01000, 2.4.1
    ORA-20004, 2.4.3
  Error Messages dialog box, 6.11
  exceptions
    no messages available (DEQUEUE test), 6.12.2.2
    PL/SQL, 7.9.1
  Expiration
    parameter for message queue profile, 6.5

## F

  file
    tnsnames.ora, 6.13.1
  file transfer program, 5.4.1.2
  FILLER, 7.12.4
  format conversion, COBOL, 7.13

## G

  gateway
    testing, 6.10
  gateway test code, 6.10
  gateway test, default, 6.10
  General panel, 6.2
  generated code package, 6.8.2
  generated code, viewing, 6.8.2
  generated package, 6.11
  GRANT statement, syntax, 6.13.2.1

## H

  hardware requirements, 3.1
  HIRE interface profile, 7.1.2
  host file, 6.2
  host name
    parameter for connecting, 6.2
  HR message queue profile, 7.1.2

## I

  IBMVSCOBOLII, 6.3
  IN parameter, 7.13.1, 7.13.7
  initialization parameter
    CLOSE_CACHED_OPEN_CURSOR, 2.4.1
  input parameter, 7.3, 7.5.3, 7.5.3.2, 7.6.3, 7.6.3.2, 7.8
  installation scripts, 5.4.1.2
  installing
    the repository, 5.4
  installing the PG4MQ Visual Workbench client, 5
  inter-application messages, 6.5
  interface procedures
    four in a MIP, 7.1.1
  interface profile, 6.1
    before you compile the MIP, 6.13.1
    compatibility with beta release, 6.8.1
    creating, 6.8
    generating a MIP, 7.1
    HIRE, 7.1.2
    introduction, 1.3.1.3
    MIP too large, 2.4.3
    removing a message queue profile, 6.7
    updating a message queue profile, 6.6
  invalid parameter, 7.3.1
  IP address, in the Host Name field, 6.2

## J

  JUSTIFIED, 7.13.1
  JUSTIFIED LEFT, 7.13.2
  JUSTIFIED RIGHT, 7.13.1

## K

  known problems, 3.2.4

## M

  mapping
    to PL/SQL, 6.3, 6.3, 6.3
  maximum open cursors, 2.4.1
  message interface package (see MIP)
  Message Interface Package Tester dialog box, 6.12.2.2
  message queue profile, 6.1
    creating, 6.5
    HR, 7.1.2
    introduction, 1.3.1.2
    removing, 6.7
    updating, 6.6
    UPS, 6.5
  message queue properties
    Acknowledgment, 6.5
    Delivery Mode, 6.5
    Dequeue Mode, 6.5
    Expiration, 6.5
    Message Type, 6.5
    Priority, 6.5
    Profile Name, 6.5
    Queue Name, 6.5
    Response Queue, 6.5
    Security ID, 6.5
    Visibility, 6.5, 6.5
    Wait Interval, 6.5
  message queuing systems, 1.1
  Message Type
    parameter for message queue profile, 6.5
  message_properties parameter, 7.5.3, 7.6.3
  MESSAGE_PROPERTIES_Typ, 7.8
  MESSAGE_PROPERTIES_Typ type definition, 7.8
  message_type parameter, 7.10.2.1
  MIP
    adding code to a template, 6.12.1
    compiling, 6.11
    contains ENQUEUE and DEQUEUE procedures, 7.1.1.2
    contents of, 7.1.1
    data profile in, 7.1.1
    database link, 7.1.1
    definition, 7.1
    DEQUEUE procedure, 7.6.1
    ENQUEUE procedure, 7.5
    example, 7.1.2
    example, DO_DEPOSIT, 6.8.2, 6.8.2
    for correct PL/SQL precision, 2.4.2
    generated data mapping package, 6.8.2
    generated templates, 6.8.2
    generating, 6.8
    generating gateway test code, 6.10
    incompatible with beta version, 2.2, 6.8.1
    introduction
      description, 1.3
    introduction to generating, 1.3.1.3
    message queue profile, 7.1.1
    migration considerations, 2.2
    overview of PG4MQ Visual Workbench development, 6.1
    parameter restrictions (a table), 7.10.2.1
    preparing for production, 1.3.1.7, 6.13
    procedures, 7.2
    testing the gateway for, introduction to, 1.3.1.4
    too large, 2.4.3
    updating, 6.9
    using a template to test, 6.12.2
    using the templates, 6.12
    using the templates, introduction, 1.3.1.6
  msgid parameter, 7.5.3, 7.6.3, 7.10.2.1

## N

  naming algorithm, PL/SQL, 7.14
  national language support
    parameter for data profile, 6.3
  NLS, see national language support
  no messages available, DEQUEUE application, 6.12.2.2
  NULL
    DEQUEUE procedure action, 7.6.3
    ENQUEUE procedure action, 7.5.3
    example syntax, 7.1.2, 7.1.2, 7.7.1.1, 7.7.2.1, 7.7.3.1, 7.8.1, 7.11
    invalid for "open_mode", 7.7.1.1
    invalid for "payload", 7.5.2.1, 7.5.3.1, 7.6.2.1
    QOPEN syntax, 7.3.1

## O

  OCCURS clause, 7.13.3, 7.13.4
  open_options parameter, 7.7.1
  OPEN_OPTIONS_Typ type definition, 7.7.1
  openOpts.open_mode parameter, 7.5.3.2
  ORA-01000 error message, 2.4.1
  ORA-20004 error message, 2.4.3
  Oracle Procedural Gateway for message queuing systems, 1.2
  Oracle SID
    parameter for connecting, 6.2
  ORCL, default SID, 6.2
  OUT parameter, 7.13.1, 7.13.7
  output parameter, 7.5.1, 7.6.1, 7.6.2.2, 7.6.3.2, 7.8

## P

  package
    data conversion, 6.10, 6.12, 7.11, 7.11, 7.11, 7.13.2, 7.13.3, 7.13.6, 7.14.2, 7.14.4
    data mapping, 6.8.2
    DBMS_OUTPUT, 5.4.1.4, 5.4.2.3, 6.13.1, A.1, A.2
    DBMS_PIPE, 5.4.2.3, 6.13.1, A.1, A.2
    generated, 6.11
    generated code, 6.8.2
    PGM_BQM, 5.4.2.5, 6.13.1, 7.9, 7.10.2, A.1, A.2
    PGM_SUP, 5.4.2.5, 6.13.1, 7.10.1, A.1, A.2
    PL/SQL, 1.3.1.3, 2.4.2, 6.13.1, 7.1, 7.11, A.1, A.2, A.3
    test code, 6.13.3
    UTL_PG, 5.4.2.4, 6.13.1, A.1, A.2
    UTL_RAW, 5.4.1.3, 5.4.2.3, 6.13.1, A.1, A.2
  panel
    General, 6.2
  parameter
    Acknowledgment, 6.5, 6.5
    COBOL copybook file, 6.3
    correlation, 7.10.2.1
    Data Definition Name, 6.3
    data length, 7.13.5
    Delivery Mode, 6.5
    Dequeue Mode, 6.5
    dequeue_options, 7.6.3, 7.7.3
    enqueue_operations, 7.5.3
    enqueue_options, 7.7.2
    Expiration, 6.5
    host name, 6.2
    if NULL, 7.5.3, 7.6.3
    IN, 7.13.1, 7.13.7
    initialization, CLOSE_CACHED_OPEN_CURSOR, 2.4.1
    input, 7.3, 7.5.3, 7.5.3.2, 7.6.3, 7.6.3.2, 7.8
    invalid, 7.3.1
    Message Type, 6.5
    message_properties, 7.5.3, 7.6.3
    message_type, 7.10.2.1
    MIP restrictions (a table), 7.10.2.1
    msgid, 7.5.3, 7.6.3, 7.10.2.1
    national language support, 6.3
    open_options, 7.7.1
    openOpts.open_mode, 7.5.3.2
    Oracle SID, 6.2
    OUT, 7.13.1, 7.13.7
    output, 7.5.1, 7.6.1, 7.6.2.2, 7.6.3.2, 7.8
    password, 6.2
    payload, 7.5.1, 7.6.1, 7.6.3
    port number, 6.2
    Priority, 6.5
    priority, 7.10.2.1
    Profile Name, 6.5
    Queue Name, 6.5
    queue_name, 7.5.3, 7.6.3, 7.10.2.1
    Response Queue, 6.5, 6.5
    response_queue, 7.10.2.1
    Security ID, 6.5
    security_id, 7.10.2.1
    to control sending and receiving messages, 7.1.1.2
    user name, 6.2
    Visibility, 6.5, 6.5
    visibility, 7.7.3.1
    Wait Interval, 6.5
  password, parameter for connecting, 6.2
  payload parameter, 7.5.1, 7.6.1, 7.6.3
  PG4MQ Visual Workbench
    components, 1.3
    development environment, 3.2.1
    development privileges for repository, 5.4.3
    installing the client, 5
    installing the repository, 5.4
    overview of development process, 6.1
    remove repository, 5.4.4
    repository, 1.3.2
    repository directory tree, 6.2
    starting, 6.2
    uses, 1.3.1
    window, 6.2
  PG4MQ Visual Workbench Wizard, 6.1, 6.8
  PGM_BQM package, 5.4.2.5, 6.13.1, 7.9, 7.10.2, A.1, A.2
  PGM_SUP package, 5.4.2.5, 6.13.1, 7.10.1, 7.10.1, A.1, A.2
  pgm8.sql, A.2
  PGMADMIN, 5.4.2.5, 5.4.4.1, 6.2
  pgmbqm8.sql script, A.2
  pgmdeploy9.sql script, A.1
  PGMDEV role, 5.4.3
  pgmsup8.sql script, A.2
  pgmundeploy9.sql script, A.1
  pgvwbremove.sql script, 5.4.4
  pgvwbrepos.sql script, 5.4.2, 5.4.3
  PIC 9, 7.12.3
  PIC G, 7.12.2
  PIC X, 7.12.1
  PL/SQL
    Code, 6.8.2
    code, 6.11
    code panel, 6.12
    data conversion package, 7.11
    incorrect precision of types, 2.4.2
    installing missing packages, A.1
    interface, 6.8
    mapping, 6.3, 6.3, 6.3, 6.3
    MIP in a PL/SQL program, 6.12
    naming algorithm, 7.14
      delimiters, 7.14.1
      duplicate names, 7.14.4
      qualified compound names, 7.14.2
      truncated and non-unique names, 7.14.3
    package, 1.3.1.3, 2.4.2, 6.13.1, 7.1, 7.11, A.1, A.2, A.3
    packages required for data conversion, 7.11
    removing packages, A.3
    verifying packages exist, A.1
  port number
    default, 6.2
    parameter for connecting, 6.2
  priority parameter, 7.10.2.1
  priority, parameter for message queue profile, 6.5
  private access privileges, 5.4.2.6
  private repository, 5.4.4.2
  privileges, private access, 5.4.2.6
  privileges, public access, 5.4.2.6
  problems, incorrect precision of PL/SQL types, 2.4.2
  procedural gateway
    database link for access, 5.4.1.6
  procedure
    DEQUEUE, 6.12, 6.12.1, 7.1.1, 7.1.1.2
    ENQUEUE, 6.12, 6.12.1, 7.1.1, 7.1.1.2, 7.5.2
    ENQUEUE, advanced, 7.5.3
    QCLOSE, 7.1.1, 7.4
    QOPEN, 7.1.1, 7.3
  production
    introduction to preparing the MIP for production, 1.3.1.7
    preparing the MIP for production, 6.13
  profile
    data, for message exchange, 6.1
    HR, 7.1.2
    interface, 6.1
    message queue, 6.1
  Profile Name
    parameter for message queue profile, 6.5
  program
    file transfer, 5.4.1.2
  prvtpg.sql script, A.2
  prvtrawb.plb script, 5.4.1.3
  public access privileges, 5.4.2.6

## Q

  QCLOSE
    close an open queue, 7.1.1.1
    procedure, 7.1.1, 7.4
    syntax, 7.4.1
  QOPEN
    open a specified queue, 7.1.1.1
    procedure, 7.1.1, 7.3
    syntax, 7.3.1
  qualified compound names, in data conversion, 7.14.2
  Queue Name
    parameter for message queue profile, 6.5
  queue_name parameter, 7.5.3, 7.6.3, 7.10.2.1

## R

  remove
    the PG4MQ Visual Workbench repository, 5.4.4
  removing a data profile, 6.4.1
  removing a message queue profile, 6.7
  RENAMES clause, 7.13.5, 7.13.6
  repository
    and compiling, 6.11
    choosing a server, 5.4.1.1
    connecting to, 6.2
    development privileges, 5.4.3
    directory tree, PG4MQ Visual Workbench, 6.2
    installation scripts, 5.4.1.2
    installing, 5.4
    installing the repository, 5.4
    PG4MQ Visual Workbench, 1.3.2
    private, 5.4.4.2
    remove, 5.4.4
    server, definition, 5.4.1.1
  requirements
    hardware, 3.1
    software, 3.2
  Response Queue
    parameter for acknowledgment message, 6.5
    parameter for message queue profile, 6.5
  response_queue parameter, 7.10.2.1
  role
    PGMDEV, 5.4.3

## S

  sample copybook files, 6.3
  script
    file directory, 5.4.1.2
    pgmbqm8.sql, A.2
    pgmdeploy9.sql, A.1
    pgmsup8.sql, A.2
    pgmundeploy9.sql, A.1
    pgvwbremove.sql, 5.4.4
    pgvwbrepos.sql, 5.4.2, 5.4.3
    prvtpg.sql, A.2
    prvtrawb.plb, 5.4.1.3
    utlpg.sql, A.2
    utlraw.sql, 5.4.1.3
  Security ID
    parameter for message queue profile, 6.5
  security_id parameter, 7.10.2.1
  SID
    (system identifier) parameter, 6.2
    default, 6.2
  software requirements, 3.2
  starting the PG4MQ Visual Workbench, 6.2
  statement
    DESCRIBE, 5.4.1.3, 5.4.1.4
    GRANT, 6.13.2.1
  SYNCHRONIZED, 7.13.7
  SYNCHRONIZED LEFT, 7.13.8
  SYNCHRONIZED RIGHT, 7.13.7
  system identifier (SID) parameter, 6.2

## T

  template
    adding code to, 6.12.1
    MIP, 6.8.2
    testing the DEQUEUE, 6.12.2.2
    testing the ENQUEUE, 6.12.2.1
    using the MIP, 6.12
    using the MIP, introduction, 1.3.1.6
    using to test the MIP, 6.12.2
  template code, 6.8.2
    to test the MIP, 6.11
  test code package, 6.13.3
  testing
    introduction to testing the gateway for a MIP, 1.3.1.4
    testing the gateway for a MIP, 6.10
  tnsnames.ora file, 6.13.1
  truncated and non-unique names
    in data conversion, 7.14.3
  type definition
    an introduction, 7.7
    DEQUEUE_OPTIONS_Typ, 7.7.3
    ENQUEUE_OPTIONS_Typ, 7.7.2
    MESSAGE_PROPERTIES_Typ, 7.8
    OPEN_OPTIONS_Typ, 7.7.1

## U

  updating
    data profile, 6.4
    message queue profile, 6.6
    MIP, 6.9
  UPS
    message queue profile, 6.5
  user name, parameter for connecting, 6.2
  UTL_PG package, 5.4.2.4, 6.13.1, 7.11, A.1, A.2
  UTL_RAW package, 5.4.1.3, 5.4.2.3, 6.13.1, 7.11, A.1, A.2
  utlpg.sql script, A.2
  utlraw.sql script, 5.4.1.3

## V

  viewing the generated code, 6.8.2
  Visibility
    DEQUEUE parameter for message queue profile, 6.5
    ENQUEUE parameter for message queue profile, 6.5
  visibility parameter, 7.7.3.1

## W

  Wait Interval
    and "no messages available" exception (DEQUEUE test), 6.12.2.2
    parameter for message queue profile, 6.5
  WebSphere MQ
    using the MIP for, 7.10.1
  WebSphere MQ Properties dialog box, 6.5
  Wizard
    PG4MQ Visual Workbench, 6.1, 6.8